package com.hkts.naturalgas.index.mapper;

import com.hkts.naturalgas.index.entity.ParamVo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface IndexMapper {
    /**
     * 统计当天登录人数
     * @return
     */
    int countHontLog(ParamVo param);
    int countInstanceinfo(ParamVo param);
    int sumInstanceinfoTime(ParamVo param);
    int countTimeOut(ParamVo param);
//    List<Map<String, Object>> totalHontLogDay(String beginDate,String endDate);
    List<Map<String, Object>> totalHontLog(String dateType, String beginDate, String endDate,String departId);
    List<Map<String, Object>> totalHontLogOnDePart(String beginDate, String endDate);

    List<Map<String, Object>> totalInstanceinfoCount(String dateType, String beginDate, String endDate,String departId);
    List<Map<String, Object>> totalInstanceinfoOnDePart(String beginDate, String endDate);
    List<Map<String, Object>> countIndexBottomAvg(String beginDate, String endDate);
    List<Map<String, Object>> countIndexBottomAvgOnUser(String beginDate, String endDate,String departId);
    List<Map<String, Object>> countIndexBottomTimeOrder(String beginDate, String endDate);
    List<Map<String, Object>> countIndexBottomTimeOrderOnUser(String beginDate, String endDate,String departId);
    List<Map<String, Object>> countIndexBottomTime(String beginDate, String endDate, Integer firstRow, Integer lastRow,String departId);

}
